REM  SQL scripts for Chapter 2 of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.


> svrmgrl
SVRMGR> connect internal
SVRMGR> alter database
     2> add logfile group 4
     3> ('/db01/oracle/CC1/log_1c.dbf',
     4>  '/db02/oracle/CC1/log_2c.dbf') size 5M;


> svrmgrl
SVRMGR> connect internal
SVRMGR> alter database
     2> add logfile member '/db03/oracle/CC1/log_3c.dbf'
     3> to group 4;



create public database link HR_LINK
connect to HR identified by PUFFINSTUFF
using 'hq';

select * from EMPLOYEE@HR_LINK
where Office='ANNAPOLIS';

create view LOCAL_EMP
as select * from EMPLOYEE@HR_LINK
where Office='ANNAPOLIS';

grant select on LOCAL_EMP to PUBLIC;


HQ =(DESCRIPTION=
      (ADDRESS=
            (COMMUNITY=TCP.HQ.COMPANY)
            (PROTOCOL=TCP)
            (HOST=HQ)
            (PORT=1521))
      (CONNECT DATA=
            (SID=loc)))



